package com.cqndt.disaster.device.dao;

import com.cqndt.disaster.device.domain.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * Create Njh
 * @Time : 2019-11-17 15:41
 **/
@Mapper
public interface ExcelMapper {
    /**
     * 添加项目
     * @return
     */
    int insertProject(ExcelProject excelProject);

    /**
     * 添加灾害点
     * @return
     */
    int insertBasic(ExcelBasic excelBasic);

    /**
     * 添加设备
     * @return
     */
    void insertDevice(ExcelDevice excelDevice);

    /**
     * 添加监测点
     * @return
     */
    void insertMonitor(ExcelMonitor excelMonitor);

    /**
     * 添加传感器
     * @return
     */
    void insertSensor(ExcelSensor excelSensor);

    /**
     * 添加监测点
     * @return
     */
    void insertDeviceInstall(ExcelDeviceInstall excelDeviceInstall);

    void insertUserDevice(ExcelUserDevice excelUserDevice);

    void insertUserProject(ExcelUserProject excelUserProject);

    Integer selectDeviceNo(@Param("deviceNo") String deviceNo);

    Integer selectProjectNo(@Param("projetcNo") String projetcNo);

    void insertDeviceType(ExcelDeviceType excelDeviceType);

    List<Map<String,Object>> export(@Param("userId")int userId);

    int selectIdByUserName(@Param("userName") String userName);
}
